|
47
|
How can I prevent grouping by a specified column
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->DataColumns->get_Item(TVariant("Freight"))->AllowGroupBy = Expivotlib_tlb::AllowGroupByEnum::exGroupByNone;
|
|
46
|
How can I sort alphabetically the columns to be displayed in the context menu/floating panel
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotBarVisible = Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarContextSortAscending | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowResizeColumns | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowUndoRedo | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAutoUpdate | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowFormatContent | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowFormatAppearance | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowValues | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarShowTotals | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAutoFit | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarSizable | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarVisible;
Pivot1->PivotColumnsSortOrder = Expivotlib_tlb::PivotColumnsSortOrderEnum::exPivotColumnsAscending;
Pivot1->PivotColumnsFloatBarVisible = true;
|
|
45
|
How can I prevent dropping data to the control
Pivot1->AllowDrop = false;
|
|
44
|
Is it possible to allow incremental filtering on drop down filter window too, as I can on the control menus
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->DisplayFilterList = Expivotlib_tlb::FilterListEnum::exHideFilterPattern | Expivotlib_tlb::FilterListEnum::exFilterListDefault;
|
|
43
|
How can I prevent showing the Filter For field in the drop down filter window
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->DisplayFilterList = Expivotlib_tlb::FilterListEnum::exHideFilterPattern | Expivotlib_tlb::FilterListEnum::exFilterListDefault;
|
|
42
|
How can I display the numeric columns only when selecting a new aggregate, like SUM
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0[bold]";
Pivot1->PivotColumns = L"sum(5)/12,count(5)/12";
Pivot1->DataColumns->get_Item(TVariant("Freight"))->SortType = Expivotlib_tlb::SortTypeEnum::SortNumeric;
|
|
41
|
How can I add a value column
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)/12";
|
|
40
|
I would like to always have the subtotals in the same row of the "father row". Could that be done
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0[bold],2";
Pivot1->PivotColumns = L"sum(5)/12,count(5)/12";
Pivot1->ShowViewCompact = Expivotlib_tlb::ShowViewCompactEnum::exViewCompactAggregates | Expivotlib_tlb::ShowViewCompactEnum::exViewCompact;
Pivot1->PivotTotals = L"/sum,sum(0)";
|
|
39
|
Is there any way, when I change the filter of the column, it broadcast the filter to the other pivot columns that were duplicated
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0,2";
Pivot1->ShowBranchRows = Expivotlib_tlb::ShowBranchRowsEnum::exBranchCompact;
Pivot1->PivotColumns = TVariant(String("sum(5)/12[filter='gBpNxjNh1MhlBoKNhpOZ0hJVNxpOhlMggKBhMZrMJnMoAgI='],count(5)/12[filter='gBpNxjNh1MhlBoKNhpOZ0hJVNxpOhlMggKBhMZ") +
"rMJnMoAgI=']");
Pivot1->ShowViewCompact = Expivotlib_tlb::ShowViewCompactEnum::exViewCompactKeepSettings | Expivotlib_tlb::ShowViewCompactEnum::exViewCompact;
|
|
38
|
How can I summarize more fields in the same cell
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0,2";
Pivot1->ShowBranchRows = Expivotlib_tlb::ShowBranchRowsEnum::exBranchCompact;
Pivot1->PivotColumns = L"sum(5)/12,count(5)/12";
Pivot1->ShowViewCompact = Expivotlib_tlb::ShowViewCompactEnum::exViewCompact;
|
|
37
|
How do I programmatically group by rows, in a compact way, no hierarchy lines
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0,2";
Pivot1->ShowBranchRows = Expivotlib_tlb::ShowBranchRowsEnum::exBranchCompact;
|
|
36
|
How do I programmatically group by rows
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0,1,2";
Pivot1->LinesAtRoot = Expivotlib_tlb::LinesAtRootEnum::exLinesAtRoot;
Pivot1->HasLines = Expivotlib_tlb::HierarchyLineEnum::exSolidLine;
|
|
35
|
How do I programmatically group by columns
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)/12;6";
|
|
34
|
How can I hide the add new button on the pivot bar
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotBarVisible = Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarHideAddNew | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowResizeColumns | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowUndoRedo | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAutoUpdate | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowFormatContent | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowFormatAppearance | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowValues | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarShowTotals | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAutoFit | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarSizable | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarVisible;
|
|
33
|
Is it possible to show the data that generated the result, when double clicking the row
Pivot1->BeginUpdate();
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0[italic]";
Pivot1->PivotColumns = L"count(0)[underline]";
Pivot1->PivotTotals = L"count[bold,strikeout]";
Pivot1->ShowDataOnDblClick = true;
Pivot1->EndUpdate();
|
|
32
|
Does your control support subscript or superscript, in HTML captions
Pivot1->HeaderHeight = 22;
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->DataColumns->get_Item(TVariant("ShipCountry"))->Caption = L"ShipCountry<font ;7><off 6><sha ;;0>subscript";
Pivot1->DataColumns->get_Item(TVariant("ShipRegion"))->Caption = L"ShipRegion<font ;7><off -6><sha ;;0>superscript";
Pivot1->Refresh();
|
|
31
|
Is it possible to define a different background color for the pivot bar
Pivot1->Background[Expivotlib_tlb::BackgroundPartEnum::exPivotBarBackColor] = RGB(240,240,240);
|
|
30
|
How can I display an icon/image to Content sub-menu
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->Images(TVariant(String("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq") +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="));
Pivot1->FormatContents->get_Item(TVariant("numeric"))->Name = L"<img>1</img> Numeric";
Pivot1->PivotRows = L"5[content=numeric]";
|
|
29
|
How can I change the selection background in the control's context menu
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->Background[Expivotlib_tlb::BackgroundPartEnum::exSelBackColorFilter] = RGB(255,0,0);
|
|
28
|
How can I display the column as date in a long format
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->FormatContents->Add(L"longdate",L"longdate(date(value))",TNoParam());
Pivot1->PivotRows = L"9[content=longdate]";
|
|
27
|
Is it possible to display the column in upper-case
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->FormatContents->Add(L"upper",L"upper(value)",TNoParam());
Pivot1->PivotRows = L"0[content=upper]";
|
|
26
|
How can I programatically bold a column
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0[bold]";
|
|
25
|
How can I display the total with a different foreground color
Pivot1->FormatAppearances->Add(L"fore",TNoParam())->ForeColor = RGB(255,0,0);
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)";
Pivot1->PivotTotals = L"sum[fore,bold]";
|
|
24
|
How can I display the total with a different background color/ebn
Pivot1->VisualAppearance->Add(1,TVariant("c:\\exontrol\\images\\normal.ebn"));
Pivot1->FormatAppearances->Add(L"back",TNoParam())->BackColor = 0x1000000;
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)";
Pivot1->PivotTotals = L"sum[back]";
|
|
23
|
How can I display the total with a solid background color
Pivot1->FormatAppearances->Add(L"back",TNoParam())->BackColor = RGB(240,240,240);
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)";
Pivot1->PivotTotals = L"sum[back]";
|
|
22
|
Is it possible to change the "bold" caption in the control's context menu
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->FormatAppearances->get_Item(TVariant("bold"))->Name = L"Ingrosat";
|
|
21
|
Is it possible to show no Exclude field in the filter window
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->DisplayFilterList = Expivotlib_tlb::FilterListEnum::exShowCheckBox | Expivotlib_tlb::FilterListEnum::exSortItemsAsc;
|
|
20
|
How can I prevent showing the drop down filter button
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->DisplayFilterList = Expivotlib_tlb::FilterListEnum::exNoItems;
|
|
19
|
How do I get the count of positive values only
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->Aggregates->Add(L"positive",TVariant("sum"),TNoParam(),TNoParam())->FormatValue = L"value < 0 ? 0 : 1";
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"positive(5)";
|
|
18
|
How do I get the sum for negative values only
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->Aggregates->Add(L"negative",TVariant("sum"),TNoParam(),TNoParam())->FormatValue = L"value < 0 ? value : 0";
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"negative(5)";
|
|
17
|
My data stores the data as strings, is it possible to load the data using Import method
Pivot1->Import(TVariant("'string 1';'string 2'#'string 3';'string 4'"),TVariant("str=`'` eor='#' eof=';' hdr=0"));
|
|
16
|
Is it possible to load data using different separators
Pivot1->Import(TVariant("item 1;item 2#item 3;item 4"),TVariant("eor='#' eof=';' hdr=0"));
|
|
15
|
Is it possible to align a column
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Expivotlib_tlb::IColumnPtr var_Column = Pivot1->DataColumns->get_Item(TVariant(0));
var_Column->Alignment = Expivotlib_tlb::AlignmentEnum::RightAlignment;
var_Column->HeaderAlignment = Expivotlib_tlb::AlignmentEnum::RightAlignment;
Pivot1->Refresh();
|
|
14
|
How can I change by code the column/rows background color
Pivot1->BeginUpdate();
Pivot1->VisualAppearance->Add(1,TVariant("c:\\exontrol\\images\\normal.ebn"));
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->FormatAppearances->Add(L"aka",TNoParam())->BackColor = 0x1000000;
Pivot1->PivotRows = L"0[aka]";
Pivot1->EndUpdate();
|
|
13
|
How can I apply by code any appearance to my list
Pivot1->BeginUpdate();
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0[italic]";
Pivot1->PivotColumns = L"count(0)[underline]";
Pivot1->PivotTotals = L"count[bold,strikeout]";
Pivot1->EndUpdate();
|
|
12
|
How can I display an icon instead SUM/Total field
Pivot1->BeginUpdate();
Pivot1->Images(TVariant(String("gBJJgBggAAwAAgACEKAD/hz/EMNh8TIRNGwAjEZAEXjAojJAjIgjIBAEijUlk8plUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq") +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9oEEwGBwWDwmFw2Hw9+xUsxGNx2Px+LyUnyGVy2VyeZAGNjIJjITjIb0OjjGi0ukAAV" +
"jILzmayWtAGejCvjLh2u3jG23O4ACx1ew11+zEYGsZZsZUe/wkZ4sYZvD4PCy8kjAzjLFjKd5WDjIz6HRvnTwUZGMZX8ZTPb8XU8Hh9cFjALjKVjK5jIv9/w9t78WdjJ" +
"IoyWr7sKjIWu+/a8Og2QAEajLaIxAzlwhB0DwQuzoECjJWw1DiMQ3D0OgAQMKwsuj8xOy0SrzFEWMdFUExbGMCRfC8ZRswMaLsiofJVHiOo+kKRs2lL2Jsh8cyQo6Ag=" +
"="));
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Expivotlib_tlb::IAggregatePtr var_Aggregate = Pivot1->Aggregates->get_Item(TVariant("sum"));
var_Aggregate->Name = L"<img>1</img> Sum";
var_Aggregate->Caption = L"<img>1</img>";
Pivot1->PivotColumnsFloatBarVisible = true;
Pivot1->FormatPivotHeader = L"iaggregate ? (caggregate + (iaggregate != 5 ? ' ' : '') + caption) : caption";
Pivot1->FormatPivotTotal = L"caggregate";
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)";
Pivot1->PivotTotals = L"sum,count";
Pivot1->EndUpdate();
|
|
11
|
How can I change the caption to be displayed when dragging an aggregate function
Pivot1->BeginUpdate();
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotColumnsFloatBarVisible = true;
Pivot1->FormatPivotHeader = L"(iaggregate ? ('<b>' + upper(caggregate) + '</b> of ' + caption) : caption)";
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)";
Pivot1->PivotTotals = L"sum,count";
Pivot1->EndUpdate();
|
|
10
|
I am using Import method, just wondering if I can rename the columns
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Expivotlib_tlb::IColumnPtr var_Column = Pivot1->DataColumns->get_Item(TVariant(0));
var_Column->Caption = L"New Caption";
var_Column->PivotCaption = L"New Pivot Caption";
Pivot1->Refresh();
|
|
9
|
Does your control support Fit-To-Page Print and Print Preview
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0,1,2";
Pivot1->ExpandAll();
/*
Select the Component\Import Component...\Import a Type Library,
to import the following Type Library:
ExPrint 1.0 Control Library
TypeLib: ExPrint.dll
to define the namespace: Exprintlib_tlb
*/
//#include "EXPRINTLIB_TLB.h"
Exprintlib_tlb::IExPrintPtr var_Print = Variant::CreateObject(L"Exontrol.Print");
var_Print->set_Options(TVariant("FitToPage = On"));
var_Print->set_PrintExts(Pivot1->DefaultDispatch);
var_Print->Preview();
|
|
8
|
How can I print the control
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0,1,2";
Pivot1->ExpandAll();
/*
Select the Component\Import Component...\Import a Type Library,
to import the following Type Library:
ExPrint 1.0 Control Library
TypeLib: ExPrint.dll
to define the namespace: Exprintlib_tlb
*/
//#include "EXPRINTLIB_TLB.h"
Exprintlib_tlb::IExPrintPtr var_Print = Variant::CreateObject(L"Exontrol.Print");
var_Print->set_PrintExts(Pivot1->DefaultDispatch);
var_Print->Preview();
|
|
7
|
How can I hide the pivot bar (hide completly)
Pivot1->PivotBarVisible = Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowResizeColumns | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowUndoRedo | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAutoUpdate | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowFormatContent | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowFormatAppearance | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowValues | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarShowTotals | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAutoFit | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarSizable;
|
|
6
|
How can I hide the pivot bar (auto-hide)
Pivot1->PivotBarVisible = Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowResizeColumns | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowUndoRedo | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAutoUpdate | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowFormatContent | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowFormatAppearance | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowValues | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAutoHide | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarShowTotals | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarSizable | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarVisible;
|
|
5
|
How can I count and get the total of a specified column
Pivot1->BeginUpdate();
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotColumnsFloatBarVisible = true;
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)";
Pivot1->PivotTotals = L"sum,count";
Pivot1->EndUpdate();
|
|
4
|
How can I add show the columns once I grouped a column
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->PivotColumnsFloatBarVisible = true;
|
|
3
|
How can I programatically group the columns
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0:D";
|
|
2
|
Is it possible to load data from a data source
/*
Select the Component\Import Component...\Import a Type Library,
to import the following Type Library:
Microsoft ActiveX Data Objects 6.1 Library
TypeLib: msado15.dll
to define the namespace: Adodb_tlb
*/
//#include "ADODB_TLB.h"
Adodb_tlb::_RecordsetPtr rs = Variant::CreateObject(L"ADOR.Recordset");
rs->Open(TVariant("Data"),TVariant("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Program Files\\Exontrol\\ExPivot\\Sample\\Access\\sample.accdb"),Adodb_tlb::CursorTypeEnum::adOpenStatic,Adodb_tlb::LockTypeEnum::adLockOptimistic,0);
Pivot1->DataSource = (IDispatch*)rs;
|
|
1
|
How can I load data
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
|